UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'HqOVdqzRy+JAAeb9ugkPng5pYjM4Sio+XZ1/gj1naXk=' 
WHERE 
  key_id = '6af26586a2b09cce8a7aaf834816c180cab92f65e8d4b15bba1ff7eecfe74494' 
  AND (
    token = 'HqOVdqzRy+JAAeb9ugkPng5pYjM4Sio+XZ1/gj1naXk=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00037