UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZKvDkan4tXvPCTMDvuLho6tYUaipnIV9cVA1jNu542g='
WHERE
key_id = 'fe80fcd16d0bd1cc99588aaee6b80f55848fbdd0e0714b53b154d9633f2495fb'
AND (
token = 'ZKvDkan4tXvPCTMDvuLho6tYUaipnIV9cVA1jNu542g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)