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