UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HI2VTiUSbZfg8iSXR85IxM6S8CXiBGV6kyMD7Udod9g='
WHERE
key_id = '6ca0aadc8d929f0e278aa9b4624ab968a226b9dade295d1412abd15de2895650'
AND (
token = 'HI2VTiUSbZfg8iSXR85IxM6S8CXiBGV6kyMD7Udod9g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)