UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sz9Nf3tGYOYYiqvYu7iKs93wZowio6Fmkb0eMhBkIyc='
WHERE
key_id = 'aa7f91d550774e47ef0b9b9862e7ab82687f33c36432924023592e53d3946e9e'
AND (
token = 'sz9Nf3tGYOYYiqvYu7iKs93wZowio6Fmkb0eMhBkIyc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)