UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+9GpQK1je00Z3bkvnXX6cZ9mnuIsrsr8wrww2Tc3tSw='
WHERE
key_id = '640b029152590d2dc3b001fd814a251505e97b33728d31d4276263f758158d4b'
AND (
token = '+9GpQK1je00Z3bkvnXX6cZ9mnuIsrsr8wrww2Tc3tSw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)