UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'P0Vw47N2kRjiamTYb40L78YvodOw5CQmih975WanfgU='
WHERE
key_id = '040bd3863abf8645c7f7291e0930d4e32179f6f6c1a28ef23b0b1576cdfbb8ea'
AND (
token = 'P0Vw47N2kRjiamTYb40L78YvodOw5CQmih975WanfgU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)