UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hVaIBn3dSEdMj6mKS4KWmiHixKCCQwTp5upx96rPFSo='
WHERE
key_id = '3b24325c23c2e2b4086e689768a4d08fe1dc32de12bcb6ff45610301e0832f8e'
AND (
token = 'hVaIBn3dSEdMj6mKS4KWmiHixKCCQwTp5upx96rPFSo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)