UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'RlyzimtROxX+34mH6L++nXvdDYcyGw4PfcM3439cB18=' 
WHERE 
  key_id = '9382c5a51f29e41b97e6460d1018525ec93b3719b848f5011ee8d0f07d3a73cc' 
  AND (
    token = 'RlyzimtROxX+34mH6L++nXvdDYcyGw4PfcM3439cB18=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00022