UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xJt2VjVhTebN/EuiT3f0J4oADik0ilvX+5xphqqs9mE='
WHERE
key_id = '97535af4fd1c676e6afa6e913982dfd29a97fce8659baa70e0b3b217445f7ace'
AND (
token = 'xJt2VjVhTebN/EuiT3f0J4oADik0ilvX+5xphqqs9mE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)