UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+2A8PkMVWZsZ9nUJr3bNu2cW4ugcLoHBLxSmcxpf9Sk='
WHERE
key_id = 'dfb487423fcfd632f8023b3dd18b80030cd2dd48430f12e73d31ace09ca8b442'
AND (
token = '+2A8PkMVWZsZ9nUJr3bNu2cW4ugcLoHBLxSmcxpf9Sk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)