UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qDgZwla4nWYDkMDuGF5RV1RZYwmTM7F24dcrc88LiDU='
WHERE
key_id = '24205ff0391361ca93581afe812e9ca45f03e282699f3bc5e2fba604200fe95e'
AND (
token = 'qDgZwla4nWYDkMDuGF5RV1RZYwmTM7F24dcrc88LiDU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)