UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'B+55r9Z/933bIJTJjwN49hshdV590vCndRCCP+GcuzM=' 
WHERE 
  key_id = '9774c81a545a85ef7af3764205795c50ca966afe73b98540ec977a7a11937956' 
  AND (
    token = 'B+55r9Z/933bIJTJjwN49hshdV590vCndRCCP+GcuzM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00052