UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tVuvtEA/iR98IzoV3PEcSu11LTDsBkUfBTtMdLVn+7c='
WHERE
key_id = 'd4d50ae94b9a15812e4913dbe457de680c5e76018b7f13018018619aee597415'
AND (
token = 'tVuvtEA/iR98IzoV3PEcSu11LTDsBkUfBTtMdLVn+7c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)