UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1NphEGKGnxgLDJRNGCDVTa4mzMNyw3LjB+qerO41lag='
WHERE
key_id = 'b7281a5e5212e8f1cca120897c86d4d7ccfa37741bfe68bd39be83d92abc11e8'
AND (
token = '1NphEGKGnxgLDJRNGCDVTa4mzMNyw3LjB+qerO41lag='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)