UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3NtOcM6fiD1ziy371K1TKSwf/ZVPA4ZMMVMJoq6OF50='
WHERE
key_id = '9a2b74d758330e8261447f477b8b7357a4edf619649d8b16893623edb14ea39e'
AND (
token = '3NtOcM6fiD1ziy371K1TKSwf/ZVPA4ZMMVMJoq6OF50='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)