UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ICkKQ13OgtdyA+crRn3td942tHQh7ktV+xY3kjVkuy0='
WHERE
key_id = 'e12162a9e2fe06f9a6b13cf5675fcfdf0e94bc9249a32ba92de8d789708d5536'
AND (
token = 'ICkKQ13OgtdyA+crRn3td942tHQh7ktV+xY3kjVkuy0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)