UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sXcbRU5O6eYBz8C/DsHPLisOH33mxg/Q/zlPQmS1Q28='
WHERE
key_id = '980c6ef7af27a04f4ede5ce5111168eda481773e1d4a7debf037d677db0c9535'
AND (
token = 'sXcbRU5O6eYBz8C/DsHPLisOH33mxg/Q/zlPQmS1Q28='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)