UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'c0gd/GrpJ6tXfDW7Ca1rQLyHa5QlDalolXLmnIGmKx8='
WHERE
key_id = 'bb301ff85ed52d16d68728a6aa1402ebec07c51774159f260dca256fe586b0f9'
AND (
token = 'c0gd/GrpJ6tXfDW7Ca1rQLyHa5QlDalolXLmnIGmKx8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)