UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zvUU+zYS5agr56vYV5AHf+rvIvv7PqsJjI123qU5JZg='
WHERE
key_id = 'dd18d163787354557a301a96b5e870280efeae15a57715f2d062dbb0e1bc83bd'
AND (
token = 'zvUU+zYS5agr56vYV5AHf+rvIvv7PqsJjI123qU5JZg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)