UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'rPv0u0SNBishL3O0OkopcosmFT1GgbvAm4/hccIbAVQ=' 
WHERE 
  key_id = 'd81524f16812e58023f16017cf681747363ac85660d1b86d6ba6efe322440191' 
  AND (
    token = 'rPv0u0SNBishL3O0OkopcosmFT1GgbvAm4/hccIbAVQ=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00022