UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QJMwNzOuavaMlIEmDMg9Kt2bFCoCFSWdVsYeFIm0y80='
WHERE
key_id = 'b54d778243d479cf80d67c5d183897215955328bb98d4f2c9579c02daf9a6016'
AND (
token = 'QJMwNzOuavaMlIEmDMg9Kt2bFCoCFSWdVsYeFIm0y80='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)