UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0/tJ9jE6lBoCOhFSIk2iMpgfqvBDS/VuYHJ11s0mOz4='
WHERE
key_id = '5195d7b6e18e380baa3d7a10b8402ee341b56fff399833d31c79978e9046ae56'
AND (
token = '0/tJ9jE6lBoCOhFSIk2iMpgfqvBDS/VuYHJ11s0mOz4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)