UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cCP5jToiiCrvwI2dPmv8ebeHADOv5MNWtXHvu1dKyiM='
WHERE
key_id = '4eabad0287e0e5f8a875911e7fccc3c671c902f73de13e78344c12345a8e526b'
AND (
token = 'cCP5jToiiCrvwI2dPmv8ebeHADOv5MNWtXHvu1dKyiM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)