UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XuC2b3EaWurAiSk5QgGjyZOnGSTprNnZ2/9EdcQ9q00='
WHERE
key_id = 'a879b2ba06e124fa164d3f093b523aa2c5d445fbf2f878e35646141528b0b104'
AND (
token = 'XuC2b3EaWurAiSk5QgGjyZOnGSTprNnZ2/9EdcQ9q00='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)