UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0ofbrJe6ntv0joHtOAjT9Nv2pRckhndwENIxdoo1jWg='
WHERE
key_id = '9e51dd9671597f6bd2033275e7effccdfbf04611816377d4a9717a1c03c7a50b'
AND (
token = '0ofbrJe6ntv0joHtOAjT9Nv2pRckhndwENIxdoo1jWg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)