UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pqdYnA4SAVX7NyZwzy57kZD28nzJ5758gRz0iX8ZcHg='
WHERE
key_id = 'f9d952de446840c1aca206d212b4e18e88efb937dbcd6d17f81febea11182d35'
AND (
token = 'pqdYnA4SAVX7NyZwzy57kZD28nzJ5758gRz0iX8ZcHg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)