UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/OEbMhf07Ua6Sj6r8l243NPq3hHejKUYE1Do85VDZeg='
WHERE
key_id = 'e7b9690460246e55f6ec293d181dfa0b4f2f2c644dc1e6290baca4d027debb1d'
AND (
token = '/OEbMhf07Ua6Sj6r8l243NPq3hHejKUYE1Do85VDZeg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)