UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7b+inA8fKCh5qc6Q8JsBkey3JVlHhRh6huKcLYGTevg='
WHERE
key_id = 'ae1957265f0f7e81c70b08b15c45721f57e7ea6a7ede506bc2eee21247a1c50a'
AND (
token = '7b+inA8fKCh5qc6Q8JsBkey3JVlHhRh6huKcLYGTevg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)