UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HIVt44qmj1iKkIicXJJMOreC4XOuou3SeqbdzRcpQd8='
WHERE
key_id = '3494337c6a3929c5c4c1b2466d3d7c29b0caddb0f1bd53d500084d1306b039be'
AND (
token = 'HIVt44qmj1iKkIicXJJMOreC4XOuou3SeqbdzRcpQd8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)