UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'V1kcqWKj7MehhzBDjWa5QC+nOVAeVWn0PRQM48e+tSg='
WHERE
key_id = '7f51b6fc6c8cac99024c609debc81f825175861a2211d88bcdc5f3a25d538147'
AND (
token = 'V1kcqWKj7MehhzBDjWa5QC+nOVAeVWn0PRQM48e+tSg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)