UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'nJqFxDj5Qv0+bwPV2ldHj36iyM5qDcVVEf4P+16nTog=' 
WHERE 
  key_id = 'b568c7ba5eadb6616068238995d6b0df40cbaad96c6ba2bb3a8d791b9fa6278c' 
  AND (
    token = 'nJqFxDj5Qv0+bwPV2ldHj36iyM5qDcVVEf4P+16nTog=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00033